package DBLayer;

import Model.Product;
import java.util.ArrayList;

/**
 *
 * Database interface for products
 * 
 * @author Group 1
 * @version 2011.03.31.
 */

public interface DbInterfaceProduct {
    
    // get all products
    public ArrayList<Product> getAllProducts();
    
    //find one product by unique value
    public Product searchById(String id);
    public Product searchByName(String name);
    
    //get products by supplier
    public ArrayList<Product> searchBySupplierId(String id);
    
    //get products by country of origin
    public ArrayList<Product> searchByCountry(String country);
    
    //insert a new product
    public int insertProduct(Product prod);
    
    //update information about a product
    public int updateProduct(Product prod);
    
    //delete product by id
    public int deleteProduct(String id);
    
}
